SyPaymentAccount_Proxy

EntityType | Independent
Logical Entity Name | SyPaymentAccount_Proxy
Default Table Name | SyPaymentAccount_Proxy
Logical Only | NO
Owner | dbo
Definition |
Note |

SyPaymentAccount_Proxy Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
SyPaymentAccount_ProxyID |  | INTEGER | NO |
RecordID |  | INTEGER | NO |
OldCode |  | CHAR(8) | YES |
NewCode |  | CHAR(8) | YES |
OldDescrip |  | VARCHAR(50) | YES |
NewDescrip |  | VARCHAR(50) | YES |
OldPartner |  | VARCHAR(50) | YES |
NewPartner |  | VARCHAR(50) | YES |
OldVendorID |  | VARCHAR(50) | YES |
NewVendorID |  | VARCHAR(50) | YES |
OldSchoolUserID |  | VARCHAR(50) | YES |
NewSchoolUserID |  | VARCHAR(50) | YES |
OldSchoolPassword |  | VARCHAR(130) | YES |
NewSchoolPassword |  | VARCHAR(130) | YES |
OldTransFeeType |  | CHAR(1) | YES |
NewTransFeeType |  | CHAR(1) | YES |
OldTransFeeNum |  | NUMERIC(12, 2) | YES |
NewTransFeeNum |  | NUMERIC(12, 2) | YES |
OldTransFeeMin |  | NUMERIC(12, 2) | YES |
NewTransFeeMin |  | NUMERIC(12, 2) | YES |
OldTransFeeMax |  | NUMERIC(12, 2) | YES |
NewTransFeeMax |  | NUMERIC(12, 2) | YES |
OldTransFeeSource |  | CHAR(1) | YES |
NewTransFeeSource |  | CHAR(1) | YES |
OldTransFeeSaBillCodeID |  | INTEGER | YES |
NewTransFeeSaBillCodeID |  | INTEGER | YES |
OldTransMin |  | NUMERIC(12, 2) | YES |
NewTransMin |  | NUMERIC(12, 2) | YES |
OldTransMax |  | NUMERIC(12, 2) | YES |
NewTransMax |  | NUMERIC(12, 2) | YES |
OldTestMode |  | BIT | YES |
NewTestMode |  | BIT | YES |
OldPasswdRandomKey |  | VARCHAR(258) | YES |
NewPasswdRandomKey |  | VARCHAR(258) | YES |
UserID |  | INTEGER | NO |
DateAdded |  | DATETIME | NO |
OldSyPaymentProcessorID |  | INTEGER | YES |
NewSyPaymentProcessorID |  | INTEGER | YES |
OldAuthAmount |  | MONEY(19, 4) | YES |
NewAuthAmount |  | MONEY(19, 4) | YES |

SyPaymentAccount_Proxy Keys

Key Name | Key Type | Keys
PK_SyPaymentAccount_Proxy_SyPaymentAccount_ProxyID | PrimaryKey | SyPaymentAccount_ProxyID

SyPaymentAccount_Proxy Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

SyPaymentAccount_Proxy Check Constraints

Check Constraint Name | CheckConstraint

SyPaymentAccount_Proxy Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.SyPaymentAccount_Proxy | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyPaymentAccount_Proxy | NO |  |  |

SyPaymentAccount_Proxy Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | System

SyPaymentAccount_Proxy Data Movement Rules

Name | Type | Rule Text/Value